CSV File Structures (Nominal Ledger Records)

(Instant Accounts Plus users only)

Field

Type

Size

 Validation

Precision

Import Type

Nominal Code

Char

8

Yes

 

Standard / Extended

Name

Char

60

 

 

Standard / Extended

Account Type

-

-

 

 

Not included

Yearly Budget (Total of Budgets Months 1-12)

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 1

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 2

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 3

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 4

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 5

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 6

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 7

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 8

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 9

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 10

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 11

Double

11

 

8 digits + 2 d.p.

Standard / Extended

Budget Month 12

Double

11

 

8 digits + 2 d.p.

Standard / Extended

 Actuals - Bfwd, Months 1-12, Future

---

---

 

 

Not Included

Prior Year Month 1

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 2

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 3

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 4

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 5

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 6

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 7

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 8

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 9

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 10

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 11

Double

11

 

8 digits + 2 d.p.

Extended

Prior Year Month 12

Double

11

 

8 digits + 2 d.p.

Extended

Memo

---

---

 

 

Not Included

Related Topics

To Import Data

Preparing Data to be Imported

Import File Details